Problem Note 37630: Ranges in Microsoft Excel 2007 files might not be deleted properly when you use the EXCEL engine
 |  |  |  |
The DATASETS procedure and the SQL procedure might not clear or delete ranges properly in Excel 2007 workbooks when you use the EXCEL engine as shown below with this PROC DATASETS code:
For example, the problem might occur if you submit a DATASET procedure similar to the following:
libname report excel 'c:\your-directory\my-excel-file.xlsx';
proc datasets lib=report;
delete myrange;
run;
quit;
libname report clear;
Similar result can occur when you submit PROC SQL with a DROP TABLE statement similar to the following:
libname report excel 'c:\your-directory\my-excel-file.xlsx';
proc sql;
drop table report.myrange;
quit;
libname report clear;
Symptoms include skipped rows or data that still remains in the range that is specified. To resolve the problem, do one of the following:
- Upgrade to the second maintenance release for SAS 9.2 (TS2M2), which fixes the problem.
- Save the .xlsx file as an .xlsS file before you delete its range.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M0 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows XP Professional | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Windows Vista | 9.2 TS2M0 | 9.2 TS2M2 | ||
Ranges in Excel 2007 file may not be properly deleted or cleared when using the Excel engine. The problem occurs in SAS® 9.2 TS2M0 and is fixed in the second maintenance release for SAS 9.2 (TS2M2).
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2009-11-02 14:01:51 |
| Date Created: | 2009-10-28 10:48:38 |